﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace KP_CommonLibrary.KP_DataAccess
{
    public class DALHelper
    {
        
        public const string PrefixStore = "";
        public const string Pattern = "{0}{1}{2}{3}";
        public const string SuffixStore = "";
        public static string SchemaOwner { get; set; }

        public static string GetInsertProc(string tableName)
        {
            return string.Format(Pattern, PrefixStore, NormalTableName(tableName), "Insert", SuffixStore);
            
        }
        public static string GetDeleteProc(string tableName)
        {
            return string.Format(Pattern, PrefixStore, NormalTableName(tableName), "Delete", SuffixStore);
        }
        public static string GetUpdateProc(string tableName)
        {
            return string.Format(Pattern, PrefixStore, NormalTableName(tableName), "Update", SuffixStore);
        }
        private static string NormalTableName(string tableName)
        {
            return tableName;
        }

    }
}
